List of rules. Rules are an encapsulation for a list of actions to perform if the rule condition passes
All items must be unique
No Additional ItemsA rule encapsulates a set of actions to perform when the rule's condition is true
No Additional PropertiesA string that represents the name of the rule.
Defines a unique identifier for this rule
A string that represents the description of the rule.
A list of stages that this specific stage depends on ie its parents that must be executed first before it gets executed. Rule dependencies can only be actions and not other rules
All items must be unique
No Additional ItemsDefines whether this rule should be skipped or not. If skipped, all the actions under this rule will be skipped
"always" "" Each additional property must conform to the following schema
Type: stringUses Fuzzy string matching to calculate similarity between strings
No Additional PropertiesMinimum Fuzzy Ratio between 0-100 (similarity score) for condition to be true
An array of actions to be executed in order.
All items must be unique
No Additional ItemsDefines a unique identifier for this rule
The description of what the arithmetic action does
A list of stages that this specific stage depends on ie its parents that must be executed first before it gets executed. Rule dependencies can only be actions and not other rules
No Additional ItemsDefines whether this rule should be skipped or not. If skipped, all the actions under this rule will be skipped
The path to be deleted.
The path to be removed.
Action Parameters
The (part of) data the function will operate on
The value to be used as the argument for the operation.
The field from which to derive the value for the operation.
The field to store the result of the operation.
The data path where the value is to be set.
The value to set. Optional if using valueFromField.
The JSON path from which to copy a value. Optional if using value.
Maps values from valueFromField to new values. Used only with valueFromField.
Sets the value based on a condition.
No Additional ItemsThe value to set if the condition is true.
The field from which to derive the value if the condition is true. Optional.
The new field to create or update with the set value.
The (part of) data the function will operate on
The field to store the result of the function.
Specifies whether the function execution should be strict.
Additional Properties of any type are allowed.
Type: object"prompt_search" "prompt_match" "prompt_classification" Each additional property must conform to the following schema
Type: stringKey-Value where key represents the search pattern and value represents the replacement
Each additional property must conform to the following schema
Type: stringThe method of splitting
The path to the data to be split.
The path that determines the criteria for splitting. Akin to 'groupBy'
The max totals per group when doing group by running totals
The left-side data
The right-side data
The criteria to use for joining
No Additional PropertiesList of fields to group the data by
No Additional ItemsThe data path where the value is to be set.
The value to set. Optional if using valueFromField.
The JSON path from which to copy a value. Optional if using value.
Maps values from valueFromField to new values. Used only with valueFromField.
Sets the value based on a condition.
No Additional ItemsThe value to set if the condition is true.
The field from which to derive the value if the condition is true. Optional.
The new field to create or update with the set value.
Used to concatenate lists of data. Different from merge in that it simply appends one list to another
No Additional PropertiesPaths to the subsets of data to be concatenated
No Additional ItemsThe conditions to be met for the joining to be done. Two datasets are only merged if both meet the criteria
Same definition as conditionGets one value from a list of data, based on the specified reducer function
Get the min or max value from the data
No Additional PropertiesModal returns the most common value and if there is a tie, it uses the priority list to break the tie. Priority reducer picks the data with the highest priority
No Additional PropertiesEach additional property must conform to the following schema
Type: stringReturns a specific item at a given index in the list
No Additional PropertiesSort a list of objects based on a specified object key
No Additional PropertiesEach additional property must conform to the following schema
Type: stringThe number, from 1, of the capture group for backreference
If no search matches the pattern, whether or not to return the whole data
Can be used when condition is set. Should be true when the condition specifies a path that should be referenced in the data
Used when appending data within a list of objects. The key specifies which object key the final result should be set in
Can be used when condition is set. Should be true when the condition specifies a path that should be referenced in the data
Used when appending data within a list of objects. The key specifies which object key the final result should be set in
The field where concatenated string should be set
This accepts both string and capture group numbers prepended with the dollar sign eg $1, $2...
Explains what this mapper does
Use this for sorting which mapper is to be executed before which ones
Conditionally summate specific colum in a list of objects if the object mets the set criteria
No Additional PropertiesThe key/field that is to be summated
Flattens an object. Child objects are removed and their values set on the parent using parent.child path notation
No Additional PropertiesA prefix for the flattened keys. Optional
Expands complex nested array into a simple one-level array of objects. Nested objects are brought to the parent level. Nested arrays are expanded and split eg ['preferences' => ['colors' => ['blue', 'green']]] becomes [['preferences.colors' => 'blue'],['preferences.colors' => 'green']]
No Additional PropertiesA prefix for the flattened keys. Optional
This first flattens the data using the flattenobjects function and then expands the list using the expandlists function
No Additional PropertiesA prefix for the flattened keys. Optional
Each additional property must conform to the following schema
Type: stringThe unit for the date difference: years (y), months (m), days (d), hours (h), minutes (i), seconds (s)
Convert quantity from one unit to another. Must take in a valid conversion table as the data. A valid conversion table is a list of objects with object keys: to (unit to convert to), from (unit to convert from), factor (the conversion multiple between the from and to units). Example: {'from': 'cm', 'to': 'm', 'factor': 0.01}
No Additional PropertiesWhether or not the factor in conversion table should be inverted or not
Convert units similar to convert_unit function but working on a list of objects data.
No Additional PropertiesThe list of objects data where each object will have the quantity converted
Each additional property must conform to the following schema
Type: stringEach additional property must conform to the following schema
Type: stringWhether or not the factor in conversion table should be inverted or not
The field path where the conversion results will be stored
Convert from one data model to another
No Additional PropertiesThe keys define the source data paths while the values define the mapped (new) data paths
Key-Value with Key as new data path and value as origin data path
Each additional property must conform to the following schema
Type: stringA List showing from and to data paths
No Additional ItemsIf inverted is yes, the mapping is done in the opposite direction ie model mapping keys will be the new data while values will be source data paths
Returns a list with all duplicate objects removed to ensure objects are unique
No Additional PropertiesKey/field to check uniqueness on
No Additional ItemsKey/field for ranking to choose on which copy of the duplicated objects to retain
The ranking ordr for the rankkeypath
Duplicate specific objects within a list. Has an option to modify the duplicated copy
No Additional PropertiesThe search key used to match the duplicated object to its replacement data
The replacement data. For each replacement, add a new property defining the replacement_key name used for search
No Additional ItemsKeys/properties define the field to replace and the property value defines the value to replace onto that field
Each additional property must conform to the following schema
Type: stringAdditional Properties of any type are allowed.
Type: objectTemplate text where variables are denoted as {{variable_name}}
Configure how the template variables in the template should matched. Number of configs should equal the number of template variables in the regex template
No Additional Items